Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_SCHEDULER_SCHEDULES

`ALL_SCHEDULER_SCHEDULES` displays information about the Scheduler schedules accessible to the current user.

Related Views

- `DBA_SCHEDULER_SCHEDULES` displays information about all Scheduler schedules in the database.

- `USER_SCHEDULER_SCHEDULES` displays information about the Scheduler schedules owned by the current user. This view does not display the `OWNER` column.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the schedule
`SCHEDULE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the schedule
`SCHEDULE_TYPE` | `VARCHAR2(8)` |  | The type of schedule. Possible values are as follows: `ONCE` - repeat interval is null `CALENDAR` - Oracle calendaring expression used as schedule `EVENT` - event schedule
`START_DATE` | `TIMESTAMP(6) WITH TIME ZONE` |  | Start date for the repeat interval
`REPEAT_INTERVAL` | `VARCHAR2(4000)` |  | Calendar syntax expression for the schedule
`EVENT_QUEUE_OWNER` | `VARCHAR2(30)` |  | Owner of the source queue into which the event will be raised
`EVENT_QUEUE_NAME` | `VARCHAR2(30)` |  | Name of the source queue into which the event will be raised
`EVENT_QUEUE_AGENT` | `VARCHAR2(30)` |  | Name of the AQ agent used by the user on the event source queue (if it is a secure queue)
`EVENT_CONDITION` | `VARCHAR2(4000)` |  | Boolean expression used as the subscription rule for the event on the source queue
`END_DATE` | `TIMESTAMP(6) WITH TIME ZONE` |  | Cutoff date after which the schedule will not specify any dates
`COMMENTS` | `VARCHAR2(240)` |  | Comments on the schedule

See Also: "DBA_SCHEDULER_SCHEDULES" "USER_SCHEDULER_SCHEDULES"